home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
CD ROM Paradise Collection 4
/
CD ROM Paradise Collection 4 1995 Nov.iso
/
business
/
ost142.zip
/
MANUAL.TXT
< prev
next >
Wrap
Text File
|
1994-03-18
|
66KB
|
1,691 lines
**********************************************************************
* *
* Office Supplies Tracker v1.42 *
* Copyright (c) 1993 by BlueCollar Software *
* *
* Published exclusively by: *
* RMH Computer Services *
* PO Box 657 *
* Beech Grove IN 46107-0657 *
* (317) 782-9903 *
* *
**********************************************************************
_______
____|__ | (R)
--| | |-------------------
| ____|__ | Association of
| | |_| Shareware
|__| o | Professionals
-----| | |---------------------
|___|___| MEMBER
RMH Computer Services is a member of the Association of Shareware
Professionals (ASP). ASP wants to make sure that the shareware
principle works for you. If you are unable to resolve a
shareware-related problem with an ASP member by contacting the member
directly, ASP may be able to help. The ASP Ombudsman can help you
resolve a dispute or problem with an ASP member, but does not provide
technical support for members' products. Please write to the ASP
Ombudsman at 545 Grover Road, Muskegon, MI 49442-9427 USA, FAX
616-788-2765 or send a CompuServe message via CompuServe Mail to ASP
Ombudsman 70007,3536.
WARRANTY
--------
Neither BlueCollar Software nor RMH Computer Services make warranty of
any kind, express or implied, including without limitation, any
warranties of merchantability and/or fitness for a particular purpose.
Neither BlueCollar Software nor RMH Computer Services shall be liable
for any damages, whether direct, indirect, special or consequential
arising from a failure of this program to operate in the manner
desired by the user. Neither BlueCollar Software nor RMH Computer
Services shall be liable for any damage to data or property which may
be caused directly or indirectly by use of the program.
IN NO EVENT WILL BLUECOLLAR SOFTWARE OR RMH COMPUTER SERVICES BE
LIABLE FOR ANY DAMAGES, INCLUDING ANY LOST PROFITS, LOST SAVINGS OR
OTHER INCIDENTAL OR CONSEQUENTIAL DAMAGES ARISING OUT OF YOUR USE OR
INABILITY TO USE THE PROGRAM, OR FOR ANY CLAIM BY ANY OTHER PARTY.
TABLE OF CONTENTS
Inventory Menu . . . . . . . . . . . . . . . . . . . . . . . . . . 1
Product Code List. . . . . . . . . . . . . . . . . . . . . . . . 1
Inventory File . . . . . . . . . . . . . . . . . . . . . . . . . 3
Vendor List. . . . . . . . . . . . . . . . . . . . . . . . . . . 5
Purchase Orders. . . . . . . . . . . . . . . . . . . . . . . . . 7
Line Items File. . . . . . . . . . . . . . . . . . . . . . . . . 8
Receiving. . . . . . . . . . . . . . . . . . . . . . . . . . . . 9
Process Line Items . . . . . . . . . . . . . . . . . . . . . . . 10
Inventory History. . . . . . . . . . . . . . . . . . . . . . . . 10
Requisitions . . . . . . . . . . . . . . . . . . . . . . . . . . . 11
Fill Requisitions. . . . . . . . . . . . . . . . . . . . . . . . 13
Department List. . . . . . . . . . . . . . . . . . . . . . . . . 14
Reports Menu . . . . . . . . . . . . . . . . . . . . . . . . . . . 14
Printer Setup Utility. . . . . . . . . . . . . . . . . . . . . . 15
User-Defined Reports . . . . . . . . . . . . . . . . . . . . . . 18
Print Purchase Orders. . . . . . . . . . . . . . . . . . . . . . 20
Utilities . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20
Sort Files . . . . . . . . . . . . . . . . . . . . . . . . . . . 20
Color Selection. . . . . . . . . . . . . . . . . . . . . . . . . 20
Purge Files. . . . . . . . . . . . . . . . . . . . . . . . . . . 21
Purge History. . . . . . . . . . . . . . . . . . . . . . . . . . 22
System Parameters. . . . . . . . . . . . . . . . . . . . . . . . 22
Print User's Manual. . . . . . . . . . . . . . . . . . . . . . . 23
Registration Form. . . . . . . . . . . . . . . . . . . . . . . . 23
Other Stuff. . . . . . . . . . . . . . . . . . . . . . . . . . . 23
Hot Keys . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 24
[F1] Help . . . . . . . . . . . . . . . . . . . . . . . . . . . 24
[F2] Help Topics . . . . . . . . . . . . . . . . . . . . . . . 24
[F3] Calculator . . . . . . . . . . . . . . . . . . . . . . . . 24
[F4] Appointment Calendar . . . . . . . . . . . . . . . . . . . 25
[F5] Edit Company Information . . . . . . . . . . . . . . . . . 28
[F10] Change Index . . . . . . . . . . . . . . . . . . . . . . . 28
Ordering Information . . . . . . . . . . . . . . . . . . . . . . . 29
Product Support . . . . . . . . . . . . . . . . . . . . . . . . . . 29
OFFICE SUPPLY TRACKER - v1.42 Page 1
======================================================================
***** Welcome to "Office Supplies Tracker" *****
Three things to remember:
-------------------------
[INS] The insert key will add a record.
[ENTER] The Enter key will edit a record.
[DEL] The delete key will delete a record.
Other stuff:
------------
Press [ESC] to exit any screen or keep pressing [ESC] to exit the
program.
Press [F1] or [F2] for Help inside the program.
==================================================
INVENTORY MENU
==================================================
-----------------
Product Code List
-----------------
Selecting this menu option gives you direct access to the product code
list. The product code list is a file of all currently defined
product codes. To add inventory to the inventory file, to place a
purchase order, or to ship a product, this file must contain an entry
for the product you are dealing with. You do not have to put all your
product codes in this file before performing any of these activities,
however. You can add them as the activities are performed if they are
not on file already.
Selecting this menu option brings up a browse window into the Product
Code List. If the file is empty, you will automatically be put into a
screen for adding your first product code. From the browse window
thereafter, your choices are as follows:
[INS] Press the insert key to add a product code.
[DEL] Press the delete key to delete the currently highlighted
product code. Note, however, that if the purchase order line items
file, the inventory file, or the inventory history file contains an
entry for this product code, you will not be allowed to delete it.
OFFICE SUPPLY TRACKER - v1.42 Page 2
======================================================================
[ENTER] Press the enter key to edit the currently highlighted record.
The product code edit screen will come up, and you will be able to
change the product code, the description, and/or the standard cost.
If you change the product code, the inventory, inventory history, and
purchase order line items files will be automatically updated so that
all reference to the old product code will be changed to the new
product code (global update).
[ESC] Press escape to return to the main menu.
You may navigate through the product code list using the cursor
navigation keys, [PgUp], and [PgDn]. Pressing [HOME] moves you to the
top of the file, pressing [END] moves you to the end of the file.
Pressing the left and right arrows shifts the fields being displayed
left and right.
You may also navigate through the file by entering a key expression.
There are two keys for this file. The default is on product code.
Therefore entering a product code or a portion of a product code will
move you to the first matching record. The other key is on product
description. You can switch to this key by pressing [F10].
Note that only one record may exist for each product code (that is,
product code is a unique key). If you try to put the same product
code on twice or if you try to change an existing product code to one
that already exists, you will not be permitted.
Product Code
------------
To complete a transaction, you must enter something at this prompt.
You are not allowed to have more than one entry in the product code
list with the same product code. If you change an existing product
code, it will also be changed automatically in the inventory,
inventory history, and purchase order line items files.
When you are adding a new record to this file, you can cancel your
transaction by pressing [ESC] when you are at the product code prompt.
Description
-----------
Enter Description.
This is any expression up to 30 characters in length to further
describe this particular product code. The description is utilized as
follows:
The description is a key field in the product code list. You can view
the product code list in description order, and find a specific
product code by entering its description (press [F10] when browsing
the product code file to switch to the description key).
OFFICE SUPPLY TRACKER - v1.42 Page 3
======================================================================
The description is a related field to the Inventory File, the
Inventory History File, and the Purchase Order Line Items File. That
is, when viewing either of these files, the description for the
product code of the current record will come up automatically.
Standard Cost
-------------
This is the default cost for this product. Whenever this product is
added to a purchase order, or if you add an inventory record directly
to the inventory file, this value will be picked up automatically.
Minumum Stock
-------------
This is the inventory level at which you will be notified that
inventory is getting low. If inventory drops below this level when
you are shipping this product, you will be notified of the current
inventory level, the quantity on order, and what the balance will be
after the shipment. You do not have to assign a minimum stock level
for a product.
--------------
Inventory File
--------------
Selecting this menu option gives you direct access to the inventory
file. The inventory file contains records of each product on file,
what locations they are stored in, how many units are on hand, and
what their costs are. There is a seperate record for each product,
location, and cost combination. Thus, product code, location, and
cost make a record unique. Attempts to create more than one record in
the inventory file with the same product code, location, and cost
combination will not be permitted.
While viewing the inventory file, you will also be able to see the
product description, standard cost for the product code, the number of
units on hand both in the location for the record you are looking at
and a total for the product you are looking at. You will also be able
to see the standard cost for the product, even though this may be
different from the actual cost of the inventory record you are looking
at.
The product description, quantity on order, total quantity on hand,
and standard cost are not fields in this file, they are fields in the
product code list and are picked up for display purposes only.
Selecting this menu option brings up a browse window into the
Inventory File. If the file is empty, you will automatically be put
into a screen for adding your first inventory record. From the browse
window thereafter, your choices are as follows:
OFFICE SUPPLY TRACKER - v1.42 Page 4
======================================================================
[INS] Press the insert key to add an inventory record.
[DEL] Press the delete key to delete the currently highlighted
inventory record.
[ENTER] Press the enter key to edit the currently highlighted record.
The inventory edit screen will come up, and you will be able to change
the product code, location, unit cost, or quantity in this record.
Any changes you make will be reflected in the Qty On Hand in the
Product Code List. Also, any changes you make will result in history
records being written to the inventory history file.
[ESC] Press escape to return to the main menu.
You may navigate through the inventory file using the cursor
navigation keys, [PgUp], [PgDn]. Pressing [HOME] moves you to the top
of the file, pressing [END] moves you to the end of the file.
Pressing the left and right arrows shifts the fields being displayed
left and right.
You may also navigate through the file by entering a key expression.
There are two keys for this file. The default is on product code.
Therefore entering a product code or a portion of a product code will
move you to the first matching record. The other key is on location.
You can switch to this key by pressing [F10].
Product Code
------------
You must make an entry here to continue. Once you do, the product
code list will be checked to see if there is a match. If there is more
than one possible product code to match your entry, a browse window
into the product code list will appear and you can select the desired
record by highlighting it and pressing the enter key. If you do not
find the desired product code, press escape.
If you enter a product code and there is not a match on the product
code list, you will be asked whether you want to add it. If you say
yes, the edit screen for the product code list will come up. If you
say no, you will be returned to the product code prompt.
Cost
----
This is the actual unit cost of the product in this location. By
default it starts with the standard cost from the product code list,
but you can change it if the actual cost is different.
Location
--------
This is the location in the warehouse that this product is being
stored in. You can store the same product in as many locations as you
need to.
OFFICE SUPPLY TRACKER - v1.42 Page 5
======================================================================
Quantity
--------
This represents the unit balance of this product for this inventory
record. You can enter a quantity of zero, but you cannot enter a
negative balance.
-----------
Vendor List
-----------
This is the vendor list. The vendor list maintains a list of valid
vendor names and addresses. Validation is performed on this file
whenever a new purchase order is placed. Also, the vendor name and
address is picked up from here and printed on purchase orders.
The file is maintained in the same manner as the product code list in
that the insert,enter,delete, and escape keys are pressed from the
vendor list browse window to perform editing functions and exiting.
The vendor list has two key fields: Vendor ID and Vendor Name. You
can view the vendor list in either order by pressing [F10] while in
the vendor list browse window.
Vendor ID
---------
This is the vendor ID number. Each vendor has a unique ID assigned.
If you try to add the same vendor ID twice to the vendor list, you
will be notified that it has already been assigned. If you change an
existing vendor ID, the purchase order master file will be updated so
that each purchase order is updated with the new vendor ID number.
Vendor Name
-----------
This is the name of the vendor. You must make an entry here. If you
enter a name that already exists for another vendor, you will be
notified that it is a duplicate. However, you are allowed to assign
the same vendor name to different records in the vendor list. This
enables you to set up more than one record for the same vendor with
different addresses and accounts.
Contact Name
------------
Type in the name of a person to contact, if applicable.
Street
------
The vendor's address consists of a street, city, state, and zip code.
This address will appear on the screen with each purchase order as
will as on all printed purchase orders. Note that none of these fields
will be in the purchase order master file, but will be picked up as
relational fields from the vendor list.
OFFICE SUPPLY TRACKER - v1.42 Page 6
======================================================================
Street 2
--------
Enter a second line of the address, if applicable.
City
----
The vendor's address consists of a street, city, state, and zip code.
This address will appear on the screen with each purchase order as
will as on all printed purchase orders. Note that none of these fields
will be in the purchase order master file, but will be picked up as
relational fields from the vendor list.
State
-----
Type in the name of the State, or Province, or whatever.
Zip Code
--------
Type in the Zip or Postal Code.
Country
-------
Enter the country, if applicable.
First Phone
-----------
Type in a phone number.
Phone For1
----------
Type in what the number is for (Voice, FAX, etc).
Second Phone
------------
Type in a phone number.
Phone For2
----------
Type in what the number is for (Voice, FAX, etc).
Third Phone
-----------
Type in a phone number.
Phone For3
----------
Type in what the number is for (Voice, FAX, etc).
OFFICE SUPPLY TRACKER - v1.42 Page 7
======================================================================
---------------
Purchase Orders
---------------
Selecting this menu option gives you direct access to the purchase
order master file and the associated line items subsidiary file. The
purchase order file is a listing of all open purchase orders.
Selecting this menu option brings up a browse window into the Purchase
order master file. Purchase order numbers are assigned automatically
each time you add a purchase order. When adding a purchase order, you
enter a vendor ID to indicate which vendor the purchase order was
placed with. If you enter a vendor ID that is not in the vendor list,
you can add it from this screen.
After a purchase order is added, a purchase order number is
automatically assigned, and you are placed into the line items
subsidiary file where you begin adding line items to the purchase
order. Each line item entered is validated against the product code
list to make sure you enter a valid product code. Product codes can
be added to the product code list if your entry is not on file. Note
that you can enter the same product code more than once, but the order
price must be different. This enables you to order the same product
from the same vendor at different prices without having to place more
than one purchase order.
Once a purchase order has been placed on file, you can gain access to
the line items by 1) highlighting the desired purchase order in the
purchase order browse window and pressing the [ENTER] key, or 2)
position the edit arrow next to "Line Items", then press the [ENTER]
key. Only the line items placed on the purchase order you are viewing
will be displayed.
You navigate through both the purchase order master file and the line
items file in the same way as you do in the product code list. That
is, using the arrow keys, [PgUp], [PgDn], entering a key expression
(in the purchase order master file the keys are on purchase order
number and vendor ID. In the purchase order line items file, the only
key is on product code).
Vendor ID
---------
This is the vendor list. The vendor list maintains a list of valid
vendor names and addresses. Validation is performed on this file
whenever a new purchase order is placed. Also, the vendor name and
address is picked up from here and printed on purchase orders.
The file is maintained in the same manner as the product code list in
that the insert,enter,delete, and escape keys are pressed from the
vendor list browse window to perform editing functions and exiting.
OFFICE SUPPLY TRACKER - v1.42 Page 8
======================================================================
The vendor list has two key fields: Vendor ID and Vendor Name. You can
view the vendor list in either order by pressing [F10] while in the
vendor list browse window.
Order Date
----------
This is the date the purchase order was placed. The default is today,
but you can change it to whatever date is correct.
Line Items File
---------------
This is the Purchase Order Line Items file. Each time you are in this
procedure, any actions you perform relate to the purchase order which
you selected prior to getting into this procedure. From here you can
do the following:
[INS] Press the insert key to add a new line item to the purchase
order.
[DEL] Highlight a line item then press the delete key to remove a
line item from the purchase order.
[ENTER] Highlight a line item then press the enter key to edit or
view a line item.
[ESC] Press the escape key to return to the purchase order screen.
Product Code
------------
You must make an entry here to continue. Once you do, the product
code list will be checked to see if there is a match. If there is more
than one possible product code to match your entry, a browse window
into the product code list will appear and you can select the desired
record by highlighting it and pressing the enter key. If you do not
find the desired product code, press escape.
If you enter a product code and there is not a match on the product
code list, you will be asked whether you want to add it. If you say
yes, the edit screen for the product code list will come up. If you
say no, you will be returned to the product code prompt.
Quantity
--------
This is the number of units of this product on order for this record.
You do not have enter a value, but if you do it cannot be less than
zero.
OFFICE SUPPLY TRACKER - v1.42 Page 9
======================================================================
Unit Cost
---------
This is the actual unit cost of the product stored in this location.
By default it starts with the standard cost from the product code
list, but you can change it if the actual cost is different.
---------
Receiving
---------
This menu option allows you to receive inventory against open purchase
orders. You will be prompted to enter a purchase order number and
date received. The purchase order master file will be checked to see
if you entered a valid purchase order number. If it is valid, all the
open line items (that is, line item records where the outstanding
balance is not zero) from the purchase order line items file will come
up on the screen one at a time. Each time, you will be prompted to
enter a location and quantity received.
If a particular line item was not received, you can skip over it by
pressing the [ESC] key at the location prompt. At the quantity prompt
you enter the actual quantity received. By default, the open balance
of the line item will come up. The actual quantity received cannot
exceed the open balance by more than 10%. That is, overshipments of
10% are allowed from vendors.
Each time you finish receiving a purchase order, you will be prompted
for a new purchase order. When you have finished all your receiving,
press the [ESC] key at the purchase order prompt and you will be
returned to the menu.
Purchase Order Number
---------------------
Enter the purchase order number you are receiving against. The number
you enter must be a valid open purchase order in the purchase order
master file. If you do not know the number, press the [ENTER] key
without making an entry, and the purchase order master file will come
up so you can select the correct one.
If you enter a purchase order number that is not on file, you cannot
add it. When you have finished receiving, press the [ESC] key at this
prompt and you will be returned to the menu.
OFFICE SUPPLY TRACKER - v1.42 Page 10
======================================================================
Date Received
-------------
Enter the actual date received. If it is today, you can press the
[ENTER] key without entering a date.
Process Line Items
------------------
Location
--------
Enter the warehouse location this product was received into. If this
item was not received at all, type in any location (XXX, for example)
and enter the quantity as zero (0). This will take you to the next
record.
You can delete all "Inventory" records with 'zero' quantity by using
the "Purge Files" utility option (discussed later).
Quantity
--------
Enter the amount actually received for this line item. The amount
received cannot be greater that 10% more than the balance of this line
item.
-----------------
Inventory History
-----------------
This is the inventory history file. This file contains a record for
each transaction that affects the inventory file. Each time inventory
is received, shipped, and each time you directly edit the inventory
file through menu option number 2, a record is written to this file to
record the affects of your entries.
Note that you cannot make changes to this file directly. You can only
view it on the screen through its browse window. Key fields include
the product code, location, and transaction date. When browsing the
file, you can switch between key fields by pressing [F10].
OFFICE SUPPLY TRACKER - v1.42 Page 11
======================================================================
==================================================
REQUISITIONS
==================================================
------------
Requisitions
------------
Selecting this menu option gives you direct access to the requisition
master file and the associated line items subsidiary file. The
requisition file is a listing of all open requisitions.
Selecting this menu option brings up a browse window into the
Requisition master file. Requisition numbers are assigned
automatically each time you add a requisition. When adding a
requisition, you enter a vendor ID to indicate which vendor the
requisition was placed with. If you enter a vendor ID that is not in
the vendor list, you can not add it from this screen.
After a requisition is added, a requisition number is automatically
assigned, and you are placed into the line items subsidiary file where
you begin adding line items to the requisition. Each line item
entered is validated against the product code list to make sure you
enter a valid product code. Product codes can not be added to the
product code list if your entry is not on file. Note that you can
enter the same product code more than once, but the order price must
be different. This enables you to order the same product from the
same vendor at different prices without having to place more than one
requisition.
Once a requisition has been placed on file, you can gain access to the
line items by 1) highlighting the desired requisition in the browse
window and striking the [ENTER] key, or 2) position the edit arrow
next to "Line Items", then press the [ENTER] key. Only the line items
placed on the requisition you are viewing will be displayed.
You navigate through both the requisition master file and the line
items file in the same way as you do in the product code list. That
is, using the arrow keys, [PgUp], [PgDn], entering a key expression
(in the purchase order master file the keys are on requisition number
and vendor ID. In the requisition line items file, the only key is on
product code).
OFFICE SUPPLY TRACKER - v1.42 Page 12
======================================================================
Department Number
-----------------
Enter the department number.
When you make an entry in this field for the first time, you
will see a 'box' telling you the entry is not on file and ask
if you want to add it. Select yes, and type in your entry.
After entries have been made to this field, you can press
[ENTER] in the blank field and choose from a list of the
departments you have previously entered.
Ordered By
----------
Enter the name of the person in this department who placed the
order.
Order Date
----------
This is the date the requisition was placed. The default is
today, but you can change it to whatever date is correct.
Line Items File
---------------
This is the Requisition Line Items file. Each time you are in this
procedure, any actions you perform relate to the requisition which you
selected prior to getting into this procedure. From here you can do
the following:
[INS] Press the insert key to add a new line item to the requisition.
[DEL] Highlight a line item then press the delete key to remove a
line item from the requisition.
[ENTER] Highlight a line item then press the enter key to edit or
view a line item.
[ESC] Press the escape key to return to the requisition screen.
Product Code
------------
You must make an entry here to continue. Once you do, the
product code list will be checked to see if there is a match.
If there is more than one possible product code to match your
entry, a browse window into the product code list will appear
and you can select the desired record by highlighting it and
pressing the enter key. If you do not find the desired
product code, press escape.
Press the [ENTER] key for choices.
OFFICE SUPPLY TRACKER - v1.42 Page 13
======================================================================
Quantity
--------
This is the number of units of this product on order for this
record. You do not have enter a value, but if you do it
cannot be less than zero.
Print Requisition
-----------------
This option will print a single requisition.
-----------------
Fill Requisitions
-----------------
This menu option enables you to fill requisitions against the
inventory. You enter a product code to fill, a quantity filled, and a
date. When you enter the product code, the inventory file is checked
to see if there are any inventory records for this product code. If
there is more than one, a window will come up that you can scroll
through to find the inventory record you want to fill from.
When you have finished all your inventory requisitions you can return
to the menu by pressing the escape key at the prompt to enter a
product code.
Product Code
------------
Enter the product code you are filling. The inventory file will be
checked to see if there are any records for the product code you
entered. If there is more than one, a window will come up which you
can scroll until the desired record is highlighted.
Each time you are at the product code prompt marks the beginning of a
transaction. When you have finished all requisitions, press the
escape key at the product code prompt, and you will be returned to the
menu.
Quantity
--------
Enter the quantity filled. This quantity represents the number of
units filled from the inventory record you selected. Therefore, the
quantity you enter cannot exceed the balance on hand in this inventory
record.
Transaction Date
----------------
Enter the date this item was filled. If it was today, you can press
the enter key without entering a date, and today's date will be picked
up automatically.
OFFICE SUPPLY TRACKER - v1.42 Page 14
======================================================================
Department Number
-----------------
Enter the department number.
When you make an entry in this field for the first time, you will see
a 'box' telling you the entry is not on file and ask if you want to
add it. Select yes, and type in your entry. After entries have been
made to this field, you can press [ENTER] in the blank field and
choose from a list of the departments you have previously entered.
Ordered By
----------
Enter the name of the person in this department.
---------------
Department List
---------------
This option will maintain a list of all the departments in the office.
It will store the department number, names of personnel in each
department, and a short description of the department's function.
When filling requisitions, you can use the list to select the person
who ordered the supplies.
Department Number
-----------------
Enter the department number.
When you make an entry in this field for the first time, you will see
a 'box' telling you the entry is not on file and ask if you want to
add it. Select yes, and type in your entry. After entries have been
made to this field, you can press [ENTER] in the blank field and
choose from a list of the departments you have previously entered.
Department Description
----------------------
Enter a brief description of this department.
==================================================
REPORTS MENU
==================================================
This menu option brings up a sub-menu of options. The options
available are as follows:
Printer Setup Utility
User-Defined Reports
OFFICE SUPPLY TRACKER - v1.42 Page 15
======================================================================
Print Purchase Orders
When you are at this menu, you can get back to the main menu by
pressing the [ESC] key, or you can select one of the available
options.
---------------------
Printer Setup Utility
---------------------
The Printer Setup Utility will allow you to define your own printer
configurations for this application. NOTE that the configuration here
pertains to ONLY the User-Defined Reports Utility. Four standard
printer configurations have been provided for your convenience.
The Printer Setup Utility is to be used in conjunction with the
built-in Report Generator. This utility enables you to define an
unlimited number of printer configurations for each report.
When you are ready to use this utility, highlight Printer Setup, then
press [ENTER], or Press the [S]. Once selected, the 'List of Printer
Configurations' will appear.
This browse window will contain the four standard printer
configurations that are provided with this applications. To add a new
configuration, press [INS] from this browse window.
The Report Generator uses three different Setup Strings to determine
how to layout the lines of text before printing begins. These strings
also determine when to skip to the next page, and what escape sequence
should be sent to the printer. The Report generator automatically
selects the setup string and the page size that best fits the report.
If one line of the report will fit in the width specified in Width 1,
the Level 1 setup string will be used. If the line of the report is
too wide for Level 1 Width, but is less than or equal to the Level 2
Width, the Level 2 setup string will be used. If the report is too
wide for the Level 2 Width, but is less than or equal to the Level 3
Width, the Level 3 setup string will be used.
If the report is still too wide, the report generator will utilize
more than one line of the page per record printed, and will print on
one line as many fields as will print without breaking, and will then
wrap to the next line.
OFFICE SUPPLY TRACKER - v1.42 Page 16
======================================================================
*******
* TIP *
*******
You can force the report generator to use the same setup string, width
and line all the time by setting all three levels to the same value.
This is a good idea when you are using 80 column paper in a 130 column
printer.
Explanation of each of the fields used to define Printer
configurations are listed below.
Configuration ID
----------------
Assigns Identification Number To Configuration
Configuration ID is a unique identifier that you assign to each new
configuration. When you want to print reports, simply add the
Configuration ID Number that corresponds to the printer that will be
used to print the report. Don't use the numbers 1 - 4 since these
numbers have already been assigned to the standard printer
configurations.
Printer Description
-------------------
Provide Brief Description Of Printer
This Field is where you enter a brief description of the printer that
this configuration will be set for. The easiest description is the
brand and type of printer. If there are several printers of the same
brand and type, you need an additional identifier such as an extra
number or letter appended.
Network Printer Number
----------------------
Printer That Reports Are Routed TO
This field contains the printer number that all reports with this
configuration should be routed to. If the program is running on a
Novell network, this number should correspond to the network-assigned
printer number, where the first network printer is number 1, the
second network printer is 2, and so on.
If the program will be running on a stand-alone PC, or if the reports
with this configuration are to be routed to a printer connected to the
first parallel port on the PC, the Network Printer Number should be
set to 0 (zero).
OFFICE SUPPLY TRACKER - v1.42 Page 17
======================================================================
Reset String
------------
Printer Escape Sequence
This field contains the escape sequence that will be sent to the
printer when the report is finished printing. This should be a string
that will rest the printer to its default powerup condition.
*******
* TIP *
*******
You should refer to the User's Manual that came with the printer for
the proper escape sequence string.
Level1/Width/Length
-------------------
Define Page Parameters
This field is used to enter setup strings, line widths, and maximum
lines per page. The number of lines per page should allow room for
printing header information. Refer to the HP Laser Jet II example
below for more information on these fields.
Level2/Width/Length
-------------------
Define Page Parameters
This field is used on a page when a report width does not fit in the
width defined in Level 1.
Level3/Width/Length
-------------------
Define Page Parameters
This field is used on a page when a report width does not fit in the
width defined in Level 2.
When you are satisfied with the new Printer Configuration, press [A]
to Accept your entries. The new configuration will be written to the
Printer Setup File. If you need to make a change, press [R] and you
will be able to make changes to the appropriate field.. Press [C] to
cancel the entire entry.
Repeat the above steps for each new Printer Configuration you want to
add.
OFFICE SUPPLY TRACKER - v1.42 Page 18
======================================================================
************************
* SAMPLE PRINTER SETUP *
************************
To follow along with this example you need to select Configuration ID
'HP', Printer Name 'HewlittPackard Laser Jet II' from the List Of
Printer Configurations. Once selected, read the following explanation
of the Level 1, Level 2, Level 3, Width and Length fields.
Notice the \027 in each of the Setup strings and Reset strings. Any
time you want to include a character in a string that cannot be
entered through the keyboard, you must enter a backslash (\) followed
by the character's ASCII value. You MUST use three positions for the
ASCII value even if it is less than 100. On a HewlittPackard Laser
Printer, the Escape key has an ASCII value of 27. \027 was entered
because three positions need to be filled. This value (\027) tells the
printer that the text to follow is not to be printed, but is to be
interpreted as the configuration information.
The Level 1 Setup String tells the report generator to set the printer
to Courier font, that 80 characters will fit on one line and that no
more than 55 lines of the page will be used.
The Level 2 Setup Sting tells the report generator to switch to the
16.6 Pica font and that 130 characters will fit on one line.
The Level 3 Setup String tells the report to stay at 16.6 characters
per inch, but to switch to Landscape (sideways) printing. Now, 170
characters will fit on one line (Width = 170) and the page length will
be reduced (Length = 40).
--------------------
User-Defined Reports
--------------------
Each report is based on a primary database you select from a window.
You select the fields you want in the report, specify upper and lower
limits of field values to select for the report, and you select a
printer configuration. If the configuration you want does not exist,
you can add a new one.
You can define as many reports as you want for each file. All reports
print in a columnar format with headings. Based on the printer
configuration you select, an effort will be made to print one record
per line by switching between print sizes and types. If a complete
record does not fit on one line, it will wrap to the next line between
two fields.
OFFICE SUPPLY TRACKER - v1.42 Page 19
======================================================================
****************
* Sample Usage *
****************
First, highlight "User-Defined Reports" and press [ENTER]. You will
see a window with the heading "List of Files". These are all the
databases in your application. IF THIS LIST IS NOT PRESENT, GO TO THE
"UTILITIES MENU" AND USE THE 'SORT FILES' OPTION.
For now, let's say you want a print-out of all the Inventory History
between the months of January and June 1993. Highlight "Inventory
History" and press [ENTER]. The bottom of the screen will ask you to
'Enter report title or esc to cancel', type in 'Inventory History Jan
to June 1993' and press [ENTER].
It will then ask for the 'Printer Configuration ID for this report',
type in any three-letter ID defined in the Printer Setup Utility (CIT
will work with most Dot Matrix printers), then press [ENTER].
After doing this, your screen will be a list of reports for "Inventory
History" It should be the only on there, so highlight it and press
[ENTER]. This will bring up a "List Of Fields" screen. These are all
the fields in the "Inventory History" database.
Highlight "Transaction Date" and press [ENTER]. A "Field Definition"
screen will appear. "Transaction Date" will be the only one there,
press [ENTER]. The screen will ask you for the lower and upper limit.
This is a way to filter out unwanted records. We will do the
filtering here. In the lower limit field type 01/01/93, press [ENTER]
to accept. In the upper limit field type 06/30/93, press [ENTER] to
accept. The report will now print only the "Inventory History"
between those two dates.
Now we're back at the "List Of Fields" screen, press [INS] to add a
new field. Using the down arrow key, highlight "Product Code" and
press [ENTER].
Continue adding fields to the report, until you have inserted the ones
you want to print out.
Upper And Lower Limit
---------------------
If you wanted a report listing all the 'Descriptions' in the files up
to, and including, those starting with the letter 'P'. Type [A] in
lower limit and [P] in upper limit. Or if you only wanted all the
'Widgets' listed, type 'Widget' in both lower and upper limits.
In any field that is numeric, you will see an additional option with
the 'Upper and Lower Limit'. It will ask you if you want a total.
Type [Y], if you want the report to total this field.
OFFICE SUPPLY TRACKER - v1.42 Page 20
======================================================================
That's it, we're finished. Press [ESC]. The program will ask you if
you want to print the report now. Highlight 'Yes' or 'No' and press
[ENTER].
If you have reports already defined and want to print one of them.
Select the database the report was defined from and press [ENTER].
Then select the report you defined and press [ENTER]. And at the
"Field Definition" screen, press [ESC].
---------------------
Print Purchase Orders
---------------------
This menu option prints all purchase orders from the purchase order
master file where the open balance of the purchase order is not zero.
It prints on each form the open line items for the purchase order as
well.
When you select this option, you will be asked whether you really want
to print the reports. If you reply with anything other than "Y" or
"y", the reports will not print.
==================================================
UTILITIES
==================================================
----------
Sort Files
----------
This menu option packs and re-indexes all files in the system.
---------------
Color Selection
---------------
If you are using a color or composite monitor, this utility will let
you change the color settings for the screens. You can also specify
whether you want windows to explode and implode.
Press [ENTER], a screen with various color combinations will appear.
Selecting different colors for your program is simple. First, move the
edit arrow next to the area you want to re-set the colors for
(GRAPHICS, DATA FIELDS, ENHANCED, or SCREEN TEXT), then press [ENTER].
Using the arrow keys to select a color combination, move the edit
arrow to the left of the color you want to select, then press [ENTER]
again. A sample of the color combination will appear in the field for
which it has been chosen.
OFFICE SUPPLY TRACKER - v1.42 Page 21
======================================================================
Graphics
--------
Graphics characters include menu boxes and screen borders.
Data Fields
-----------
Data fields are the regions of data input(reverses video region). For
example, aa data field has a field length of 10, 10 spaces of the
color selected here will appear on the screen. It is in these 10
spaces that you will make your entries.
Enhanced
--------
This changes the colors of the SELECTED menu choices and other
highlight bar options.
Screen Text
-----------
All text displayed on the screen will use this color combination.
Exploding Windows
-----------------
This is a YES/NO option. It is used to determine whether or not your
application will have windows that explode onto the screen or sneak
into view.
-----------
Purge Files
-----------
This menu option, when selected, automatically performs the following:
Deletes from the inventory file all records where the inventory
quantity is zero.
Deletes from the purchase order master file all records where the
purchase order value is zero.
Deletes from the purchase order line items file all records where
the quantity on order for a line item is zero.
This process takes place automatically. When it is complete, you are
returned to the menu.
OFFICE SUPPLY TRACKER - v1.42 Page 22
======================================================================
-------------
Purge History
-------------
This menu option prompts you to enter a date through which to delete
records from the inventory history file.
Date through which to purge
---------------------------
All records with a transaction date prior to the date you enter will
be deleted from the inventory history file. For your protection, the
date must be at least 30 days ago.
If you have changed your mind about performing this process, press the
[ESC] key at the date prompt and you will be returned to the menu.
-----------------
System Parameters
-----------------
This menu option gives you access to the system parameters file. This
file keeps track of the last purchase order number used as well as the
various tone toggles.
Last Purchase Order Number: You can increase it by increments no
greater than 100 at a time, and you cannot reduce it.
Tone Toggles: You can turn on/off the various tones that sound when
running this program.
Last P.O.
---------
This field keeps track of the last purchase order number assigned to a
purchase order. Each time a purchase order is placed, this field is
incremented by one. You can change the value of this field, but there
are limitations. First, you cannot reduce it, since you may cause a
duplicate purchase order number to be assigned.
Second, you can increase it by no more than 100 at a time. This is for
your protection. If you were to increase it by a large value, you
would be skipping over many purchase order numbers, and would not be
able to switch it back.
Under normal circumstances, you should have no reason to change this
field at all.
OFFICE SUPPLY TRACKER - v1.42 Page 23
======================================================================
Get Beep
--------
If this field is set to TRUE, a tone will sound whenever the user
fills a field.
Error Beep
----------
If this field is set to TRUE, a tone will sound whenever the user
makes a data entry error.
Alert Beep
----------
If this field is set to TRUE, a tone will sound at certain points to
make the user aware of various conditions. These are conditions that
are not necessarily wrong, but the user should still be made aware.
-------------------
Print User's Manual
-------------------
Print the User's Manual, or view it on-screen.
-----------------
Registration Form
-----------------
Print the Registration form, or view it on-screen.
-----------
OTHER STUFF
-----------
The arrow keys will move the calculator around on the screen to get it
out of the way of something you might want to look at.
Pressing ALT-F10 will bring up a screen that allows you to change the
colors of the calculator. It works pretty similar to the color
selection utility. I'm not typing out all the information about that
again, I've been sitting here too long already. Play around with it,
you'll figure it out.
OFFICE SUPPLY TRACKER - v1.42 Page 24
======================================================================
=================================================
HOT KEYS
=================================================
There are various "Hot Keys" available, which are active throughout
the program. Pressing any of these Hot Keys will activate the feature,
and it will "pop up" over the current screen.
---------
F1 - HELP
---------
Pressing [F1] will bring up a Help window corresponding to the field
that you are currently in.
----------------
F2 - HELP TOPICS
----------------
Pressing [F2] will bring up a scrollable listing of all the various
Help Topics. You can scroll through the list using the Up and Down
Arrow keys, and then press [ENTER] on the selected topic for detailed
Help.
---------------
F3 - CALCULATOR
---------------
This HotKey will pop up a calculator.
ACTIVE KEYS ACTION
------------------------------------------------------------
[+] Addition
[-] Subtraction
[*] Multiplication
[/] Division
[^] Exponentiation
[%] Percentage
[C] Clear current total
[E] Clear current entry
[D] Change number of decimals displayed
[R] Round to specific number of decimals
[P] Print (adding machine mode)
[M] Memory operations (see "Memory Functions")
[=] Process operation
[Enter] Process operation
[Backspace] Erase last digit entered
[Esc] Exit Calculator
OFFICE SUPPLY TRACKER - v1.42 Page 25
======================================================================
Memory Functions
----------------
To access the Memory Functions, press [M].
ACTIVE KEYS: ACTION:
-----------------------------------------------------
[R] Recall number stored in memory
[C] Clear memory (reset to zero)
[+] Add current number to memory
[-] Subtract current number from memory
[*] Multiply memory by current number
[/] Divide memory by current number
Print--Adding Machine Mode
--------------------------
By pressing [P] for print, the calculator emulates an adding machine.
This will be noted by a small 'P' next to the numbers window. Each
calculation will be sent to the printer (if it is on- line). After
all, if you've invested several thousands of dollars in PC hardware
and software, why spend more for a ten-digit adding machine? Press
[P] again to toggle adding machine mode off.
-----------------
F4 - APPOINTMENTS
-----------------
This is a multi-user calendar with an appointment tracker. You can
point and shoot at any date and add, edit, and delete appointments for
that date. You may also print and delete appointments for any range
of dates. More advanced featured allow you to add periodically
recurring appointments, and to view days and weeks at a glance to
determine when you have free time to schedule an appointment.
When you first enter the calendar, the current month will be displayed
along with the first two weeks of the following month. The current
day will blink, and holidays will be in red (on color monitors). If
there are any appointments for the current day, the first seven will
be displayed in a window at the bottom of the screen. Other days that
have appointments will be displayed in reverse video on the calendar.
OFFICE SUPPLY TRACKER - v1.42 Page 26
======================================================================
ACTIVE KEYS ACTION
--------------------------------------------------------------
[Left Arrow] Go backward one day
[Right Arrow] Go forward one day
[Up Arrow] Go backward one week
[Down Arrow] Go forward one week
[PgUp] Go back one month
[PgDown] Go forward one month
[HOME] Jump to first day of month
[END] Jump to last day of month
[ENTER] Add/Edit/View appointments
[P] Print appointments
[D] Delete appointments
[T] Daily time block
[W] Weekly time blocks
[C] Jump to current date (system)
[S] Search for text in either description
or notes of an appointment.
[ESC] Exit calendar
Adding/Editing/Viewing Appointments
-----------------------------------
Use the navigation keys to move to the desired date, the press
[ENTER]. A browse window will appear near the bottom of the screen
showing the time and description for all appointments. If there are
no appointments for that date, you will automatically be placed in the
Add mode. The following options are available at this point:
[A] Add new appointments
[E] Edit highlighted appointment
[D] Delete highlighted appointment
[M] Move highlighted appointment
[R] Recurring appointment
[N] edit Notes for highlighted appointment
[ESC] Exit calendar
To add a new appointment press [A]. Enter the user ID (This is who
the appointment is for, not who it is with), along with the starting
and ending time and a brief description of the appointment.
*** NOTE ***
The TIME is a twenty-four hour clock. 3:00 PM would be 15:00, 9:00 AM
would be 09:00 (You have to add the preceding '0' before 9:00.
The ending time cannot be earlier than the starting time. In addition,
if you try to enter an appointment that creates a time conflict with
an already existing appointment, you will get an error message to that
effect. Press [CTRL]-[W] to save the new appointment or [ESC] to exit
without saving.
OFFICE SUPPLY TRACKER - v1.42 Page 27
======================================================================
To edit a highlighted appointment, press [E]. Make your changes, but
the same rules apply from the Add mode. Press [CTRL]-[W] to save the
new appointment or [ESC] to exit without saving.
To delete a highlighted appointment, press [D]. You will be asked to
confirm your request, respond by pressing [Y]es or [N]o.
You may move appointments from one day to another by pressing [M]. A
window will appear and ask you for the new date for this appointment.
To add a recurring date, press [R]. Follow the same steps as when
adding a single appointment. After you press [CTRL]-[W], you will be
given the following options:
i Every day of the week (Mon, Tues, etc.)
ii Every other day of week
iii Every...day of the month (1st, etc.)
iv Every day
v Every...day-of-week (e.g. 3rd Monday, etc.)
vi Every weekday
Highlight the desired option and press [ENTER].
To add or edit notes for the highlighted appointment, press [N]. A
window will open below the appointment window, into which you may type
away to your heart's content. Press [CTRL]-[W] to save your edits, or
[ESC] to exit without saving. Appointments that have notes attached to
them will have a checkmark displayed to the right of the description.
To exit back to the calendar, press [ESC].
Printing Appointments
---------------------
To print an appointment, press [P]. You then have the option of
printing for the current week, or for a range of dates. If you print
for a week, you will be asked for a specific user ID (or "ALL" if you
print for all users). If you print for a range of dates, you will be
prompted to enter the starting and ending dates. If there are no
appointments in that range, you will be informed. Otherwise, you will
be asked if you want to include the Notes.
Deleting Appointments
---------------------
To delete all appointments for a range of dates, press [D]. You will
be asked to enter the starting and ending dates. The number of
effected appointments will be displayed, and you will be asked to
confirm your request. Press [Y]es, if you want to delete them, or
[N]o, if you chicken out.
OFFICE SUPPLY TRACKER - v1.42 Page 28
======================================================================
Time Blocks--Daily
------------------
As previously mentioned, when you are in the calendar and appointments
exist for the current date, they will be displayed in a window near
the bottom of the screen. However, let's say your in a hurry and need
to know what times are available during the day. Press [T]. A graph
showing available and used time blocks will be displayed. The graph
starts at 06:00 and ends at 22:00. Each block represents a fifteen
minute interval. There will be one row for each person who has an
appointment on this date.
Time Blocks--Weekly
-------------------
Weekly time blocks are similar to daily time blocks, but not as
detailed. When you press [W], you will be presented with a daily
breakdown of appointments for the current week. In this display, each
daily graph begins at 06:00 and ends at 17:00, and each block
represents an interval of one hour.
--------------------------------
F5 - Edit Company Name & Address
--------------------------------
This option will bring up the Company Name & Address window, where you
can edit and update the information. This windows comes up
automatically when the program is 1st run, and the F5 HotKey allows
you to edit or update it later.
Please note that this information is not used for "printed" output in
the shareware version. However, the registered version will use this
information automatically when printed output requires the company
name & address.
---------------------
F10 - CHANGE INDEXING
---------------------
In any browse screen you may choose a different way to index that
particular file by pressing [F10]. Use the arrow keys to select the
desired index and press [ENTER]. The browse screen will sort the files
the way you tell it to.
OFFICE SUPPLY TRACKER - v1.42 Page 29
======================================================================
=================================================
ORDERING INFORMATION
=================================================
To register your copy of Office Supplies Tracker, you can mail a check or
money order directly to us. Simply print a copy of the registration
for, which is supplied in the file REGISTER.TXT. This form may be
printed from within the program by selecting the "Registration Form"
option from the UTILITIES pull-down menu. Alternately, you can print
it directly from the DOS command line by issuing the following
command:
COPY REGISTER.TXT PRN
Then, just fill it out and mail it any your payment to the address
shown on the form.
CREDIT CARD PAYMENTS:
---------------------
You can also register your copy of Office Supplies Tracker using your
credit card (VISA/MasterCard only) by calling 317-782-9903.
=================================================
PRODUCT SUPPORT
=================================================
Registered users are entitled to full product support via mail or
telephone for a period of not less than 90 days. Support may also be
obtained via Compuserve email, and other electronic services. If
technical problems in the software are discovered within 90 days of
registration, RMH Computer Services will, at their option, either
provide a workable solution to the problem or a refund of the
registration cost. After the initial 90 days, RMH Computer Services
is only obligated to make reasonable effort to supply a revised copy
of the software.
Support for unregistered users will be available in regards to product
installation and basic program operation.
Support via mail is available at RMH Computer Services, PO Box 657,
Beech Grove IN 46107-0657 USA. Telephone support is available at
317-782-9903 between the hours of 08:00am - 06:00pm EST. Email
support is also available via our BBS at 317-784-2147 24hrs/day (*).
You may also direct email to Richard Holler via Compuserve
[73567,1547], INTERNET:73567.1547@compuserve.com, FidoNet NetMail
1:231/290, and RIME private/routed email ->5056.
(*) When logging on to the BBS, using the name RMH COMPUTER, and a
password of SERVICES will take you directly to the RMH Computer
Services support/distribution area, and will bypass all of the 1st
time caller questionnaires.